Driver, template, calc method, and other updates

Calc Methods

Issue	Description
Stat_Rev and Expense tabs: Inserted calc method lines and data do not return on rebuild [TFS 50080]	Issue: After inserting calc methods in the Stat_Rev and Expense tabs, inserting data, and then saving successfully, the system does not query and display the calc methods and data in both tabs when rebuilding the plan file using the Scheduler job. Resolution: Corrected the Build & Process Budget Files Scheduler job to check the Active check box for AQs 8-9 on the Stat_rev tab and AQ13 on the Expense tab. IMPORTANT: Manual correction needed. For instructions, see Manual configuration instructions and technical considerations.
PFB-09270 - Formula issue in I/P and O/P Rev lines in Add Department Initiative calc method [TFS 61629]	Issue: In the Initiative template, in the Add Department Initiative 77 line calc method, in the I/P Revenue row (row 6), the monthly formulas in columns I through T are currently locked to a range ending on row 499. This means that when you add initiatives below row 499, the formula is no longer valid. Resolution: Corrected by adjusting the ranges for both the IP/OP sections down to Total Patient Revenue.

Issue

Description

Stat_Rev and Expense tabs: Inserted calc method lines and data do not return on rebuild [TFS 50080]

Issue: After inserting calc methods in the Stat_Rev and Expense tabs, inserting data, and then saving successfully, the system does not query and display the calc methods and data in both tabs when rebuilding the plan file using the Scheduler job.

Resolution: Corrected the Build & Process Budget Files Scheduler job to check the Active check box for AQs 8-9 on the Stat_rev tab and AQ13 on the Expense tab.

IMPORTANT: Manual correction needed. For instructions, see Manual configuration instructions and technical considerations.

PFB-09270 - Formula issue in I/P and O/P Rev lines in Add Department Initiative calc method [TFS 61629]

Issue: In the Initiative template, in the Add Department Initiative 77 line calc method, in the I/P Revenue row (row 6), the monthly formulas in columns I through T are currently locked to a range ending on row 499. This means that when you add initiatives below row 499, the formula is no longer valid.

Resolution: Corrected by adjusting the ranges for both the IP/OP sections down to Total Patient Revenue.

Templates

Issue	Description
PFB-08697 - When using the Staffing Labor tab in a budget plan file and in the Other Dept Pay section, column CQ references column CM [TFS 46615]	Issue: When using the Staffing Labor tab and in the Other Dept Pay section of a budget plan file, the use of PayrollGLMapping was failing. The core issue is that we are missing formulas for the use of PayrollGLMapping to resolve correctly when using the Dept Pay section of the Staffing tab. Once we resolve for use of PayrolLGLMapping, the formulas will work in all cases, meaning: No PayrollGLMapping is used. NoBudget Group PayrollGLMapping. BudgetGroup PayrollGLMapping. Resolution: Corrected by adding the new Dept Other Pay section calc method's required lookups to identify details in work area columns related to Payroll GL Exception Mapping.
PFB-08886 - Duplicate new job codes on Staffing tab [TFS 48865]	Issue: The system adds duplicate new job code blocks on the Staffing tab after save. Resolution: Corrected by identifying duplicates for the Add New JobCode calc method and added logic to prevent duplicates.
PFB-09233 - BP Stat_Rev calc methods missing Red Flag warning [TFS 56642]	Issue: When reviewing preliminary budget plan files, the Red Flags do not populate on the Stat_Rev tab when appropriate. Resolution: Corrected the logic used to display the red flag to end-user based on calculations in adjacent columns across the calc method library.
PFB-09298 - Drill03Transaction and Drill09JE pick up wrong department description [TFS 61606]	Issue: The KHA_Drill03Transaction and KHA_Drill09JE include GetData() in cell A15, which pulls the DEPT description for the report title. The filter parameter uses DEPT.KHABgtMAP, which can return the incorrect description if there are multiple mapped departments. Resolution: Corrected by modifying the formula used to look up the department description based on Dept.Description versus what was formerly Dept.KHABgtMap.Description.

Provider

Issue	Description
PFB-08671 - Provider Summary methodology, the calc method does not project out volume [TFS 48331]	Issue: When using the Provider Summary methodology, the calc method displays 0 in the Volume line in the projection column. Resolution: Corrected by updating the Add New Summary calc method to use the formula similar to other calc methods in column K.
PFB-08884 - ProviderSummary Calc Method Index range on column [TFS 52074]	Issue: Errors occur when reprocessing BUD2021 plan files in the Provider file. This issue was that column S and V included an Index formula with a range that was limited to approximately 5000 rows. This caused an error in the plan file when the range limit was exceeded. Resolution: Corrected the ProviderSummary calc method by increasing the ranges of index functions in columns S and V.
PFB-08978 - Revenue increase formula on ProviderSummary tab [TFS 50617]	Issue: In the Provider template, the system does not apply revenue increases correctly. Cell H52 in the ProviderSummary tab contains a formula with an incorrect reference to cell X66. Resolution: Corrected the formula with the correct cell.
PFB-09191 - Provider Seasonality - User saved changes revert with Expand All Providers [TFS 56161]	Issue: On the ProviderDetail tab, if a user modifies the monthly budget values for the Seasonality row and saves the plan file, and then re-opens the plan file, their saved numbers display (and they are indeed saved to the BUD_PROV_yyyy table). However, if they click the link to Expand All Provider details, the system replaces their monthly numbers with the default (1.0) Seasonality. Resolution: Corrected a conflicting timing issue where a record should save, but the SaveTagCustom clears due to an earlier save.
PFB-09246 - Provider Vol formula on ProviderComp calc method [TFS 57072]	Issue: The formula in column AE, row 2 of line 40 in the ProviderComp calc method is not working properly. In the GetData section of the formula, if referencing the ProviderVol driver table, AE$12 references the NYBSumcolumn, which does not exist in the ProviderVol table (column in ProviderVol is named NYBTtl). Resolution: To mitigate column discrepancies related to associated columns for a table, corrected by adjusting GetData with the static value for the column titled NYBTtl.